﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace ThoiTrangT2B
{
    public partial class UCFooter : System.Web.UI.UserControl
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            LoadFooter();
            LoadFooterLR();
        }

        private void LoadFooter()
        {
            string sql = "SELECT NoiDung FROM dbo.tblT2BWebContent WHERE MaDM = 'footer'";
            ltrFooter.Text = SqlHelper.ExecuteScalar(CommandType.Text,sql).ToString();
        }

        private void LoadFooterLR()
        {
            string sql = "SELECT NoiDung FROM dbo.tblT2BWebContent WHERE MaDM IN ('fleft','fright')";
            DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql);
            fleft.Text = dt.Rows[0]["NoiDung"].ToString();
            fright.Text = dt.Rows[1]["NoiDung"].ToString();
        }
    }
}